package com.huike.pmps.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.huike.pmps.model.entity.Supplier;
import com.huike.pmps.model.entity.SupplierEvaluates;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Update;

import java.util.List;


/**
 * 作者：谌贵斌(黑桃K)
 * 日期: 2888-08-08
 * 老师QQ: 272488352
 * 官方QQ交流群: 377748272
 * 刀客程序员官网：http://www.daoke360.com
 * 刀客程序员淘宝旗舰店：https://daoke360.taobao.com/
 */
public interface SupplierEvaluatesDao extends BaseMapper<SupplierEvaluates> {


    /**
     * 批量插入SupplierEvaluate数据
     */
    @Insert({
            "<script>",
            "insert into p_supplier_evaluates(supplier_id, supplier_name, service_type, shoot_level, post_production, delivery2_level, delivery3_level, service_attitude, appraise, communicate_skill, delivery_schedule, po_id, course_id, course_name, po_course_id, po) values ",
            "<foreach collection='list' item='se' index='index' separator=','>",
            "(#{se.supplierId},#{se.supplierName},#{se.serviceType},#{se.shootLevel},#{se.postProduction},#{se.delivery2Level},#{se.delivery3Level},#{se.serviceAttitude}, #{se.appraise}, #{se.communicateSkill}, #{se.deliverySchedule}, #{se.poId}, #{se.courseId}, #{se.courseName}, #{se.poCourseId}, #{se.po})",
            "</foreach>",
            "</script>"
    })
    int insertSupplierEvaluatesBatch(List<SupplierEvaluates> list);

}
